package com.doublechaintech.retailscm.employeeinterview;

import java.math.BigDecimal;
import java.util.List;
import java.util.stream.Stream;
import java.util.Map;
import com.terapico.caf.baseelement.CandidateQuery;
import com.doublechaintech.retailscm.BaseDAO;
import com.doublechaintech.retailscm.BaseEntity;
import com.doublechaintech.retailscm.SmartList;
import com.doublechaintech.retailscm.MultipleAccessKey;
import com.doublechaintech.retailscm.RetailscmUserContext;

import com.doublechaintech.retailscm.employee.Employee;
import com.doublechaintech.retailscm.interviewtype.InterviewType;

import com.doublechaintech.retailscm.interviewtype.InterviewTypeDAO;
import com.doublechaintech.retailscm.employee.EmployeeDAO;

public interface EmployeeInterviewDAO extends BaseDAO {

  public SmartList<EmployeeInterview> loadAll();

  public Stream<EmployeeInterview> loadAllAsStream();

  public EmployeeInterview load(String id, Map<String, Object> options) throws Exception;

  public void enhanceList(List<EmployeeInterview> employeeInterviewList);

  public void collectAndEnhance(BaseEntity ownerEntity);

  public void alias(List<BaseEntity> entityList);

  public EmployeeInterview present(EmployeeInterview employeeInterview, Map<String, Object> options)
      throws Exception;

  public EmployeeInterview clone(String id, Map<String, Object> options) throws Exception;

  public EmployeeInterview save(EmployeeInterview employeeInterview, Map<String, Object> options);

  public SmartList<EmployeeInterview> saveEmployeeInterviewList(
      SmartList<EmployeeInterview> employeeInterviewList, Map<String, Object> options);

  public SmartList<EmployeeInterview> removeEmployeeInterviewList(
      SmartList<EmployeeInterview> employeeInterviewList, Map<String, Object> options);

  public SmartList<EmployeeInterview> findEmployeeInterviewWithKey(
      MultipleAccessKey key, Map<String, Object> options);

  public int countEmployeeInterviewWithKey(MultipleAccessKey key, Map<String, Object> options);

  public Map<String, Integer> countEmployeeInterviewWithGroupKey(
      String groupKey, MultipleAccessKey filterKey, Map<String, Object> options);

  public EmployeeInterview disconnectFromAll(String employeeInterviewId, int version)
      throws Exception;

  public void resetNextId();

  public SmartList<EmployeeInterview> queryList(String sql, Object... parameters);

  public List<String> queryIdList(String sql, Object... parameters);

  public Stream<EmployeeInterview> queryStream(String sql, Object... parameters);

  public int count(String sql, Object... parameters);

  public CandidateEmployeeInterview executeCandidatesQuery(
      CandidateQuery query, String sql, Object... parmeters) throws Exception;

  public SmartList<EmployeeInterview> findEmployeeInterviewByEmployee(
      String employeeId, Map<String, Object> options);

  public int countEmployeeInterviewByEmployee(String employeeId, Map<String, Object> options);

  public Map<String, Integer> countEmployeeInterviewByEmployeeIds(
      String[] ids, Map<String, Object> options);

  public SmartList<EmployeeInterview> findEmployeeInterviewByEmployee(
      String employeeId, int start, int count, Map<String, Object> options);

  public void analyzeEmployeeInterviewByEmployee(
      SmartList<EmployeeInterview> resultList, String employeeId, Map<String, Object> options);

  public SmartList<EmployeeInterview> findEmployeeInterviewByInterviewType(
      String interviewTypeId, Map<String, Object> options);

  public int countEmployeeInterviewByInterviewType(
      String interviewTypeId, Map<String, Object> options);

  public Map<String, Integer> countEmployeeInterviewByInterviewTypeIds(
      String[] ids, Map<String, Object> options);

  public SmartList<EmployeeInterview> findEmployeeInterviewByInterviewType(
      String interviewTypeId, int start, int count, Map<String, Object> options);

  public void analyzeEmployeeInterviewByInterviewType(
      SmartList<EmployeeInterview> resultList, String interviewTypeId, Map<String, Object> options);

  List<EmployeeInterview> search(EmployeeInterviewRequest pRequest);
}
